home *** CD-ROM | disk | FTP | other *** search
/ Microsoft Internet Strate…Tools for the Enterprise / Microsoft Internet Strategy & Tools for the Enterprise.iso / bkoffice / inetsrv.nts / mips / scripts / samples / query.idc < prev    next >
Text File  |  1995-12-29  |  396b  |  15 lines
  1. Datasource: Web SQL
  2. Username: sa
  3. Template: query.htx
  4. SQLStatement:
  5. +SELECT FirstName, LastName
  6. +FROM Guests
  7. +WHERE FirstName like '%FirstName%'
  8. +and LastName like '%LastName%'
  9. +and (WebUse like '%WebMaster%'
  10. +  or WebUse like '%WebSurfer%'
  11. +  or WebUse like '%ISV%'
  12. +  or WebUse like '%ContentProvider%'
  13. +  or WebUse like '%WebIntegrator%')
  14. DefaultParameters:FirstName=%,LastName=%
  15.